<template>
  <div>
    <div class="gva-search-box">
      <el-form :inline="true" :model="searchInfo" class="demo-form-inline" @keyup.enter="onSubmit">
      <el-form-item label="创建时间">
      <el-date-picker v-model="searchInfo.startCreatedAt" type="datetime" placeholder="开始时间"></el-date-picker>
      —
      <el-date-picker v-model="searchInfo.endCreatedAt" type="datetime" placeholder="结束时间"></el-date-picker>
      </el-form-item>
        <el-form-item>
          <el-button type="primary" icon="search" @click="onSubmit">查询</el-button>
          <el-button icon="refresh" @click="onReset">重置</el-button>
        </el-form-item>
      </el-form>
    </div>
    <div class="gva-table-box">
      <div class="gva-btn-list">
        <el-button type="primary" icon="plus" @click="openDialog">新增</el-button>
        <el-popover v-model:visible="deleteVisible" placement="top" width="160">
          <p>确定要删除吗？</p>
          <div style="text-align: right; margin-top: 8px;">
            <el-button type="primary" link @click="deleteVisible = false">取消</el-button>
            <el-button type="primary" @click="deleteSelectedRow">确定</el-button>
          </div>
          <template #reference>
            <el-button icon="delete" style="margin-left: 10px;" :disabled="!multipleSelection.length" @click="deleteVisible = true">删除</el-button>
          </template>
        </el-popover>
      </div>

      <el-table
        ref="multipleTable"
        style="width: 100%"
        border
        :header-cell-style="{background:'#a3c6d2',color:'#849ba1'}"
        tooltip-effect="dark"
        :data="tableData"
        row-key="ID"
        @selection-change="handleSelectionChange"
      >
        <el-table-column type="selection" width="55" />
        <el-table-column align="left" label="日期" :show-overflow-tooltip="true">
          <template #default="scope">{{ formatDate(scope.row.CreatedAt) }}</template>
        </el-table-column>
        <el-table-column align="left" label="标识码" prop="bsm" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="字符集" prop="charSet" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="字段注释" prop="colComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="是否主键" prop="colKey" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="列名" prop="colName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="列类型" prop="colType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="数据类型" prop="dataType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="示例数据" prop="exampleData" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="是否外键" prop="foreignKey" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="是否索引" prop="index" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="可否为空" prop="isNull" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="字段最大长度" prop="maxLength" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods列名称" prop="odsColName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods列类型" prop="odsColType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods数据类型" prop="odsDataType" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods列注释" prop="odsColComment" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods字段标签" prop="odsLabel" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods数据库id" prop="odsDbId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods模式id" prop="odsDbSchemaId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods数据表id" prop="odsDbTbId" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods模式名" prop="odsSchemaName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="ods表名称" prop="odsTbName" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="备注" prop="remarks" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="时间格式" prop="timeFormat" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="是否唯一" prop="unique" :show-overflow-tooltip="true" />
        <el-table-column align="left" label="操作" width="150" fixed="right">
          <template #default="scope">
            <el-button type="primary" link icon="edit" class="table-button" @click="updateUdsFldFunc(scope.row)">变更</el-button>
            <el-button type="primary" link icon="delete" @click="deleteRow(scope.row)">删除</el-button>
          </template>
        </el-table-column>
        </el-table>
        <div class="gva-pagination">
          <el-pagination
          layout="total, sizes, prev, pager, next, jumper"
          :current-page="page"
          :page-size="pageSize"
          :page-sizes="[10, 30, 50, 100]"
          :total="total"
          @current-change="handleCurrentChange"
          @size-change="handleSizeChange"
        />
        </div>
    </div>
    <el-dialog v-model="dialogFormVisible" :before-close="closeDialog" title="弹窗操作">
      <el-form :model="formData" ref="elFormRef" label-position="right" :rules="rule" label-width="130px">
        <el-form-item label="标识码:" prop="bsm">
          <el-input v-model="formData.bsm" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="字符集:" prop="charSet">
          <el-input v-model="formData.charSet" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="字段注释:" prop="colComment">
          <el-input v-model="formData.colComment" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="是否主键:" prop="colKey">
          <el-input v-model="formData.colKey" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="列名:" prop="colName">
          <el-input v-model="formData.colName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="列类型:" prop="colType">
          <el-input v-model="formData.colType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="数据类型:" prop="dataType">
          <el-input v-model="formData.dataType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="示例数据:" prop="exampleData">
          <el-input v-model="formData.exampleData" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="是否外键:" prop="foreignKey">
          <el-input v-model="formData.foreignKey" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="是否索引:" prop="index">
          <el-input v-model="formData.index" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="可否为空:" prop="isNull">
          <el-input v-model="formData.isNull" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="字段最大长度:" prop="maxLength">
          <el-input v-model.number="formData.maxLength" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods列名称:" prop="odsColName">
          <el-input v-model="formData.odsColName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods列类型:" prop="odsColType">
          <el-input v-model="formData.odsColType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods数据类型:" prop="odsDataType">
          <el-input v-model="formData.odsDataType" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods列注释:" prop="odsColComment">
          <el-input v-model="formData.odsColComment" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods字段标签:" prop="odsLabel">
          <el-input v-model="formData.odsLabel" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods数据库id:" prop="odsDbId">
          <el-input v-model.number="formData.odsDbId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods模式id:" prop="odsDbSchemaId">
          <el-input v-model.number="formData.odsDbSchemaId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods数据表id:" prop="odsDbTbId">
          <el-input v-model.number="formData.odsDbTbId" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods模式名:" prop="odsSchemaName">
          <el-input v-model="formData.odsSchemaName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="ods表名称:" prop="odsTbName">
          <el-input v-model="formData.odsTbName" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="备注:" prop="remarks">
          <el-input v-model="formData.remarks" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="时间格式:" prop="timeFormat">
          <el-input v-model="formData.timeFormat" placeholder="请输入" />
        </el-form-item>
        <el-form-item label="是否唯一:" prop="unique">
          <el-input v-model="formData.unique" placeholder="请输入" />
        </el-form-item>
      </el-form>
      <template #footer>
        <div class="dialog-footer">
          <el-button @click="closeDialog">取 消</el-button>
          <el-button type="primary" @click="enterDialog">确 定</el-button>
        </div>
      </template>
    </el-dialog>
  </div>
</template>

<script>
export default {
  name: 'UdsFld'
}
</script>

<script setup>
import {
  createUdsFld,
  deleteUdsFld,
  deleteUdsFldByIds,
  updateUdsFld,
  findUdsFld,
  getUdsFldList,
  getAllUdsFlds
} from '@/api/udsFld'

import { getDictFunc, formatDate, formatBoolean, filterDict } from '@/utils/format'
import { ElMessage, ElMessageBox } from 'element-plus'
import { ref, reactive } from 'vue'

const formData = ref({
  bsm: '',
  charSet: '',
  colComment: '',
  colKey: '',
  colName: '',
  colType: '',
  dataType: '',
  exampleData: '',
  foreignKey: '',
  index: '',
  isNull: '',
  maxLength: 0,
  odsColName: '',
  odsColType: '',
  odsDataType: '',
  odsColComment: '',
  odsLabel: '',
  odsDbId: 0,
  odsDbSchemaId: 0,
  odsDbTbId: 0,
  odsSchemaName: '',
  odsTbName: '',
  remarks: '',
  timeFormat: '',
  unique: '',
})

const rule = reactive({
})

const elFormRef = ref()


const page = ref(1)
const total = ref(0)
const pageSize = ref(10)
const tableData = ref([])
const searchInfo = ref({})

const onReset = () => {
  searchInfo.value = {}
  getTableData()
}

const onSubmit = () => {
  page.value = 1
  pageSize.value = 10
  getTableData()
}

const handleSizeChange = (val) => {
  pageSize.value = val
  getTableData()
}

const handleCurrentChange = (val) => {
  page.value = val
  getTableData()
}

const getTableData = async() => {
  const table = await getUdsFldList({ page: page.value, pageSize: pageSize.value, ...searchInfo.value })
  if (table.code === 0) {
    tableData.value = table.data.list
    total.value = table.data.total
    page.value = table.data.page
    pageSize.value = table.data.pageSize
  }
}

getTableData()


const setOptions = async () =>{
}

setOptions()

const multipleSelection = ref([])
const handleSelectionChange = (val) => {
  multipleSelection.value = val
}

const deleteRow = (row) => {
  ElMessageBox.confirm('确定要删除吗?', '提示', {
    confirmButtonText: '确定',
    cancelButtonText: '取消',
    type: 'warning'
  }).then(() => {
    deleteUdsFldFunc(row)
  })
}


const deleteVisible = ref(false)

const deleteSelectedRow = async() => {
  const ids = []
  if (multipleSelection.value.length === 0) {
    ElMessage({
      type: 'warning',
      message: '请选择要删除的数据'
    })
    return
  }
  multipleSelection.value &&
    multipleSelection.value.map(item => {
      ids.push(item.ID)
    })
  const res = await deleteUdsFldByIds({ ids })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === ids.length && page.value > 1) {
      page.value--
    }
    deleteVisible.value = false
    getTableData()
  }
}

const type = ref('')

const updateUdsFldFunc = async(row) => {
  const res = await findUdsFld({ ID: row.ID })
  type.value = 'update'
  if (res.code === 0) {
    formData.value = res.data.reudsFld
    dialogFormVisible.value = true
  }
}


const deleteUdsFldFunc = async (row) => {
  const res = await deleteUdsFld({ ID: row.ID })
  if (res.code === 0) {
    ElMessage({
      type: 'success',
      message: '删除成功'
    })
    if (tableData.value.length === 1 && page.value > 1) {
    page.value--
    }
    getTableData()
  }
}

const dialogFormVisible = ref(false)

const openDialog = () => {
  type.value = 'create'
  dialogFormVisible.value = true
}

const closeDialog = () => {
  dialogFormVisible.value = false
  formData.value = {
    bsm: '',
    charSet: '',
    colComment: '',
    colKey: '',
    colName: '',
    colType: '',
    dataType: '',
    exampleData: '',
    foreignKey: '',
    index: '',
    isNull: '',
    maxLength: 0,
    odsColName: '',
    odsColType: '',
    odsDataType: '',
    odsColComment: '',
    odsLabel: '',
    odsDbId: 0,
    odsDbSchemaId: 0,
    odsDbTbId: 0,
    odsSchemaName: '',
    odsTbName: '',
    remarks: '',
    timeFormat: '',
    unique: '',
  }
}
const enterDialog = async () => {
  elFormRef.value?.validate( async (valid) => {
    if (!valid) return
    let res
    switch (type.value) {
      case 'create':
        res = await createUdsFld(formData.value)
        break
      case 'update':
        res = await updateUdsFld(formData.value)
        break
      default:
        res = await createUdsFld(formData.value)
        break
    }
    if (res.code === 0) {
      ElMessage({
        type: 'success',
        message: '创建/更改成功'
      })
      closeDialog()
      getTableData()
    }
    })
}
</script>

<style>
</style>
